Evaluate rows number in a table

Description

Evaluate rows number in a table is a Process Entry in the Conditions Plugin for Process Studio Processes. You can get the number of rows in a target table by connecting to the table or you can write a custom SQL statement to get the number of rows. You can you evaluate the number of rows and branch the process based on the evaluation.

Configurations

No.	Field Name	Description
1	Process Entry name	Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2	Connection	Name of the database connection on which the target table resides.
3	Target schema	The name of the Schema for the table to write data to.
4	Target table name	Name of the target table.
	Success Condition:
1	Success when rows count	For the success condition you can check the number of rows if they are: - Equal to - Different from - Smaller than - Smaller or equal to - Greater than - Greater or equal to
2	Limit	Give a numerical limit for the conditions above.
	Custom SQL:
1	Custom SQL	Check this option when you want to specify a custom SQL statement in the below field
2	Use variable substitution	Variables in the SQL statements will be substituted.
3	Clear list of result rows	Clears the internal list of result rows before executing.
4	Add rows to result	Adds all rows returned from the SQL statement within the internal list of result rows. This list of result rows can then be used in subsequent process entries to loop over or e.g. within a workflow by the Get rows from result step.